﻿-- =============================================
-- Script Template
-- =============================================
USE [IC.NET]
GO
SELECT 'ExposureCategory' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM ExposureCategory UNION
SELECT 'ExposureCacheRole' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM ExposureCacheRole UNION
SELECT 'DETargetArea' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DETargetArea UNION
SELECT 'DESenderRole' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DESenderRole UNION
SELECT 'DERecipientRole' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DERecipientRole UNION
SELECT 'DEKeyword' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DEKeyword UNION
SELECT 'DEExplicitAddress' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DEExplicitAddress UNION
SELECT 'DEDistributionReference' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DEDistributionReference UNION
SELECT 'DEContentKeyword' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DEContentKeyword UNION
SELECT 'DEConsumerRole' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DEConsumerRole UNION
SELECT 'DEXMLContent' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DEXMLContent UNION
SELECT 'DEOther' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DEOther UNION
SELECT 'DEOriginatorRole' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DEOriginatorRole UNION
SELECT 'DENonXMLContent' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DENonXMLContent UNION
SELECT 'DEMain' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DEMain UNION
SELECT 'DEContentObject' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DEContentObject UNION
SELECT 'ExposureCache' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM ExposureCache
GO